-
Re: Update a cell automatically in secondary sheet when cell is updated in intake sheet.
@EmilyRamirez try this: =INDEX (COLLECT ({sheet 1 BU}, {sheet 1 property name}, [Property Name]@row),1)1 · -
Re: Help converting an Excel formula to work in SS
@Peggy Parchert -- Hey, change your formulas as follows (everything will have appropriate number of zeroes now, no matter what): Hour: =IF(LEN([Time Value]@row) = 0, "", IF(FIND("hour&…1 · -
Re: Using DataMesh to Split One Line Onto Multiple Lines (for Forms Entries and Other Uses)
You rock. Looks perfect, thanks so much!1 · -
Re: Using DataMesh to Split One Line Onto Multiple Lines (for Forms Entries and Other Uses)
Gah. My bad @WtaylorW. Use NOT(ISBLANK()) in that formula instead of ISBLANK().2 ·